Manager, Data Engineering
Hachette Book Group is a leading trade publisher in the U.S., and a division of Hachette Livre, the third largest trade and educational publisher in the world. Headquartered in New York, HBG also has major offices in Boston, MA, Lebanon, IN, and Nashville, TN. HBG publishes under the divisions of Little, Brown and Company, Little Brown Books for Young Readers, Grand Central Publishing, Orbit, Hachette Books, Hachette Nashville, Perseus Books and Hachette Audio. HBG also provides a wide range of custom distribution, fulfillment, digital and sales services to third party publishers.
The Manager, Data Engineering will join the HBG Data Group Technology, which consists of ETL, DW and EDI teams, to provide data efficiently with excellent quality for business intelligence, analytics and reporting. Additionally, the group will make data translation and delivery between internal and external systems efficient and bulletproof. Initially, the candidate will focus primarily on leading the ETL team.
The Manager, Data Engineering will join the HBG Data Group Technology, which consists of ETL, DW and EDI teams, to provide data efficiently with excellent quality for business intelligence, analytics and reporting. Additionally, the group will make data translation and delivery between internal and external systems efficient and bulletproof. Initially, the candidate will focus primarily on leading the ETL team.
Key Responsibilities:
1. Design and develop complex Informatica ETL processes that integrate data from multiple sources including Oracle, flat files, etc.
2. Perform business analysis and develop data flow diagrams and mapping specifications
3. Interact with business users to gather data requirements
4. Give direction on parameters for construction of appropriate test cases for validation of PowerCenter and ETL processes
5. Provide guidance on the operational considerations and administrative processes for management of ETL processes
6. Interact with the technical architect for identification and design of monitoring processes
7. Provide guidance and work with the data architect in reviewing and validating the data warehouse data model
8. Assist Informatica, Stonebranch, Oracle and Microstrategy developers in debugging performance related challenges
9. Provide level 2 production support
10. Manage and coach ETL team members
1. Design and develop complex Informatica ETL processes that integrate data from multiple sources including Oracle, flat files, etc.
2. Perform business analysis and develop data flow diagrams and mapping specifications
3. Interact with business users to gather data requirements
4. Give direction on parameters for construction of appropriate test cases for validation of PowerCenter and ETL processes
5. Provide guidance on the operational considerations and administrative processes for management of ETL processes
6. Interact with the technical architect for identification and design of monitoring processes
7. Provide guidance and work with the data architect in reviewing and validating the data warehouse data model
8. Assist Informatica, Stonebranch, Oracle and Microstrategy developers in debugging performance related challenges
9. Provide level 2 production support
10. Manage and coach ETL team members
Minimum Required Qualifications:
1. Master degree in technology related field
2. 3+ years of hands on experience in ETL and Informatica
3. 3+ years of leadership experience in managing and guiding offshore team
4. 3+ years of collaboration experience with other stakeholders such as system architects and business analysts.
5. 3+ years of production support experience in addressing system outage under extreme pressure.
Required Skills:
* Informatica - PowerCenter ETL - PL/SQL - Oracle - Stonebranch - Visio - MS Project - Jira - Shell scripts, PL/SQL, and Windows/Unix Env.
Desirable Skills:
1. Experience in building systems to support book publishing industry
1. Master degree in technology related field
2. 3+ years of hands on experience in ETL and Informatica
3. 3+ years of leadership experience in managing and guiding offshore team
4. 3+ years of collaboration experience with other stakeholders such as system architects and business analysts.
5. 3+ years of production support experience in addressing system outage under extreme pressure.
Required Skills:
* Informatica - PowerCenter ETL - PL/SQL - Oracle - Stonebranch - Visio - MS Project - Jira - Shell scripts, PL/SQL, and Windows/Unix Env.
Desirable Skills:
1. Experience in building systems to support book publishing industry
As a leading book publisher, we believe that including and representing diverse voices in all aspects of our business is fundamental to what we do. Our publishing programs must reflect the broad range of backgrounds, experiences, political views and ideas that shape our society and publish books for all readers.
Hachette Book Group provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
The compensation range for this position is $161,000-$171,000. Salary can vary based on a number of factors including skills, experience, and location — talk with your recruiter to learn more. There may be times that you will be required (or requested) to work overtime due to the nature of your role or exceptional workload issues or special projects.
The following benefits are offered by the company: medical, dental, vision, basic and supplemental life, short-term and long-term disability, accidental death and dismemberment, critical illness, hospital indemnity, long-term care, health and dependent care FSA, commuter benefit plan, employee assistance program, tuition reimbursement, travel assistance, 401(k), discretionary bonus program, PTO (15 vacation days, 3 personal days, 10 holidays and generous sick leave) and group discounts on auto and home insurance and legal services. Eligibility requirements apply to some benefits and may depend on your job classification, hours worked and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms.